MacWorld 1999 January

home *** CD-ROM | disk | FTP | other *** search

/ MacWorld 1999 January - Disc 2 / Macworld (1999-01) (Disk 2).dmg / Shareware World / Utilities / Data & Time Management / SQLPlugin 1.2 / EXAMPLE1 (.txt) < prev next >

Wrap

FileMaker Pro Database | 1998-10-24 | 237.0 KB | 408 lines | [FMP3/FMP3]

work makAll play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All HBAM2016AUG95 Pro 3.0 All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a goodCopyright 1984-1997 Claris Corporation and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. GIFfA GIFf@ HBAM3016AUG95@ PTION e Pluggie (Plugname varchar(32), SUP_ID numeric, PRICE float, SALES numeric, TOTAL numeric) FEES values('French_Roast', 00049, 8.99, 0, 0) ', 00049, 8.99, 0, 0) 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 10/24/98 Arial MS Sans Serif Pro 3.0 - 4.0F! Sunday Monday Tuesday Wednesday Thursday Friday Saturday January February March April August September October November December 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter CREATE DATABASEOPENSTRING DATASOURCE INSERT PASSWORD REPORTING RESULT STATUS USERNAME statusB resultB createB datasourceB UserNameB PasswordB databaseopenstringB & "|" & & "|" & insertB A reportingB Arial MS Sans Serif 1XCEPTIONK 11lbK 11lbK n1lbK 11lbK buttlerG baneH n1lbK 1char(40), STREET varchar(40),CITY varchar(20), STATE char(2), ZIP char(5)) STATE char(2), ZIP char(5)) ODBC DatasourceY UserNameZ Password` Createa Insertb Queryf Raw Row Datau Database Connectionv Create Tablesw Insertx Queryy GetRow{ DATABASE STATUS~ Reporting o/f SQL Plugin ar(5)) |("SQL-execQuery" SQL-execQuery getRow |("SQL-getRow" SQL-getRow Arial MS Sans Serif Arial MS Sans Serif |("SQL-open" SQL-open doSql insertl insert7 |("PDM SQL-doSQL" PDM SQL-doSQL doSql create |("PDM SQL-doSQL" PDM SQL-doSQL Arial MS Sans Serif query getRow doSql insert doSql create enableReporting query query getRow doSql query @VA SQLPlugin A SQLPluginB |("SQL-doSQL" SQL-doSQL doSql create |("SQL-doSQL" SQL-doSQL enableReporting Arial MS Sans Serif Verdana Helvetica select * from PluggieEfcreate table Pluggie (Plugname varchar(32), SUP_ID integer, PRICE float, SALES integer, TOTAL integer)J;insert into Pluggie values('SQL Plugin', 0001, 49.95, 0, 0) select * from SUPPLIERSC+1|49|myCoffee|1 LaPlace|Amersfoort|CA|95460E{create table SUPPLIERS (SUP_ID int, SUP_NAME varchar(40), STREET varchar(40), CITY varchar(20), STATE char(2), ZIP char(5))JVinsert into SUPPLIERS values(49, 'myCoffee', '1 LaPlace', 'Amersfoort', 'CA', '95460') {{{{{{ ssssss ZZZZZZ JJJJJJ BBBBBB 999999 111111 !!!!!! .{{RR uAk]o uuB93Qd~ 3LeJn uutB9 e Re^npt )--!! e R_Ji q{m'( =ee_E e'Ree_J}h *)*)*)* )*)*))* );*)*)**)*)*)*)**! ReReWnY E_eeE_E =ee_eeEe_ee_E Ree^n E_eE_ EeEeeRec vuut$F _E_eE_eEe_ee_eeR^Ng =eeEe_E _Ee_E_e_e_eEeWOoG EeeEeeVi[?; ruut$F =ee_EeeE_e_Ee_ee_R_'|T* Ee^U`T7 _ee_E_eeWOoP8/00 nZOPMFKLWMKCA=;@OYVLDIFIF=9>QTQMPOMOXa^UQQTXKOBODE@FOR`WXJLRXTQFB:CZ`[TWXVF@53 {{xqwx xwolhfk{ xotrtrhdj| |x|zx{ rvzmzopkqz} |rnfo jEA:CBMNUNUKDCAFFJMGG@<@BB?><CCSJPPXZNGDAA<AAHAHFNLEBDKVPPHHKPMKBFCUUZNQTJ;46< rnfooyz xpomrsvyttlhlookjioo %p@@` /:K_g uut$F _eeE_e_Ee_JiTD; =eeEee_ ^VYT7/ :RRe^ =e_e_eeE_eRW\SP8 :ReeR^y 4#&nts u]XX@B %""mnfr u]XJ?> u]X]PH A-(}xw{ u]XfJD 6%#roeo u]X[B? +)'wvu~ u]XPEC ,%!qlw~ u]XPB= u]X_MP u\XgPK <(#uoq t[XaD> /"'mvl oYWS?C A OIGH 3,'{tsz to[VVWHC &#!"!! ;+(vqhn}ukd_ \[YVTW_GC < E@9@ 7*(oicovmd^ZY WVW[YEC %E>:9:>=A43'-2879AICC:9CB:9<F51 EeeReJio50/ vuut$F =ee_Ee_e_Ji[)0/ _ee_x tpnnhmrntmtszyqopx ||ttx}ywoso ueXW[ }vLIB 30*&#!i`X -# rrkl umR@< 1-'# vkdcKC zd^aMK EQD1.. :&'svbt y_Z_CC ("$lp| v]YL>? ,)"wnns u]XPE> u]XjSM 8+){y u]X\HE 4$%oro u]XX@@ 2++{|tv u]XWHF ;+%{st u]X_HA **1++ u u u u u u u u u u u u q{m'(( ).*-! q{q'( *)**)) ).*-! ++.++ 959;MV\WGIPUVOMN<CIhjebVLHK[VTOO_XRB@FMQRKQFLBE=PPVFJQIM FJ;=BLKEMK^OXUaS<3=FQJH959;MV\WGIPUVOMN<CIhjebVLHK[VTOO_XRB@FMQRKQFLBE=PPVFJQIMFJ;=BLKEMK^OXUaS<3=FQJH959;MV\WGIPUVOMN<CIhjebVLH K[VTOO_XRB@FMQRKQFLBE=PPVFJQIMFJ;=BLKEMKVTQPVZ]NMGMGHKJKRSQPUL"2E[s }njnp q{m'( *)*)*)*)*)*)*)* *))*) *)*)*)*)* +#++. +,.++ u u u u u u u u q{m'( *)*)*)*)*)*)*)* *)*)*)* *)**- ,*1++ ,#++. u u u u u u u u u GDODF=;> Arial MS Sans Serif Verdana Helvetica Times Arial MS Sans Serif Verdana Helvetica Times ',:@EJG E)9/&6;@@72-4@8?058>E=BC?DCIF<939?F:3%'#,*me _)cbeYWLQW][]emhg^]gf^]`jYUEKP^dinkjii]SJZ_drd[WRXd]cTY]bibfhchgmj`]W]cj_WII?GE z{{~} tsglrxwy uq`fly yofu{ x~pux~ |ysy~ zrdcT[Y \/+-/*)"&$" *))%-1/*!$)01,0/1+)(%#)+1,-,.+&#+0212($$).**&+01(&"&(792)+'! %-/(" VONNGF>CA?<= BJMLG>@ELNIMLNGFEB@FHMIJIKGC@HLN NDD@@FKGGCHMMDC>CESVOEHD=16BIKC=:;skge]\TYWTRR\[[W`ca]SV[bd^cad][ZXV[^c `]XV^b ZVV[`]]X^ccZYTXZile[^YSFKX_`XQMO *}10$ !'((.0..($ %*/'/3;G #($%)-/()(&-,.& $ )!'"%""!%%!" #NLPM@;=BDCIKIIC@56>DD?88@FJBKOVIB9=9:>C@AEHJDECrBHGIA9@;D=B>A>==AA<>8A;;7559ENK?9?jfgcUOQWXX^`^^XTIKSYYTMMU[_W_ck^VNRNOSXTUZ]_XZXV]\^VNTPYQWRURRQUUQRMUPPLIINYb_SNT |("SQL-enableReporting" "1") SQL-enableReporting |("SQL-enableReporting" "0") SQL-enableReporting Arial MS Sans Serif Verdana Helvetica EeeE_ vB&<\oP7/ E_ee_ XS[]0/ Eee_Eee^ Eee_e_eE _Ee_eEeEe_ee_eRE _eeEeeEeeJ _E_eE_ h)/0/R E_eEeeE_ReU _eE_e_ xHV^eeE_eE EeeE_eeEeeREU Z>^eRee_ee_ee_eE_e_ sgNV^eReEeeE _e_eE_eeReU sgNV_eReE E_eeEb sg>W^ sgac^eeReb lHJ_eb ^VYT7/ e R_x =e_eeE^OST8 _EeR_w ))RRss ))BBZZ 99RRkk 11JJcc 99ZZ{{ !!99RR =e_'|T7 /KRee_e_ <^UYT7 q{m'( *)*)* *)*))*)*)*)*)**! 99ZZBB kk{{ss ZZ{{kk BBZZRR 99ZZRR cckkkk RRZZZZ ZZcccc JJRRRR 99BBBB ccssss 119999 RRcccc BBRRRR !!)))) BBZZZZ 99RRRR JJkk{{ !!BBRR 11cc{{ JJccss ))BBRR 11ZZss ))RRkk 11RRkk ))JJcc ~~ypsn |}ozy ~~ypsn |}ozy ~~ypsn |}ozy siut|o{|wuxzyw wns{pmf| siut|o{|wuxzyw wns{pmf| siut|o{|wuxzyw wns{pmf| NOQUUWWQOEL@KHTPB;:GJNGJHUJJLKDAFFH@8:Lc\E:?CFBRQ]W^RTPGKHYWQQ[fna^TNOOXPG=JJULROQUUWWQOEL@KHTPB;:GJNGJHUJJLKDAFFH@8:Lc\E:?CFBRQ ]W^RTPGKHYWQQ[fna^TNOOXPG=JJULROQUUWWQOEL@KHTPB =eeEeWO[50/ Vi[D0/